Parallel Pointer-Based Join Algorithms in Memory-mapped Environments
نویسندگان
چکیده
Three pointer-based parallel join algorithms are presented and analyzed for environments in which secondary storage is made transparent to the programmer through memory mapping. Buhr, Goel, and Wai [11] have shown that data structures such as B-Trees, R-Trees and graph data structures can be implemented as efficiently and effectively in this environment as in a traditional environment using explicit I/O. Here we show how higher-order algorithms, in particular parallel join algorithms, behave in a memory mapped environment. A quantitative analytical model has been developed to conduct performance analysis of the parallel join algorithms. The model has been validated by experiments.
منابع مشابه
Parallel Pointer-based Join Techniques for Object-Oriented Databases
In this paper, we describe four parallel pointer-based join algorithms for set-valued attributes. Pointer-based joins will be common in next-generation object-oriented database systems, so efficiently supporting them is crucial to the performance of such systems. Using analysis, we show that while algorithms based on Hybrid-hash provide good performance, algorithms that require less replication...
متن کاملTechnische Universität München Institut für Informatik B richt Massively Parallel Sort - Merge Joins in Main Memory Multi - Core Database Systems
Two emerging hardware trends will dominate the database system technology in the near future: increasing main memory capacities of several TB per server and massively parallel multi-core processing. Many algorithmic and control techniques in current database technology were devised for disk-based systems where I/O dominated the performance. In this work we take a new look at the well-known sort...
متن کاملMassively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems
Two emerging hardware trends will dominate the database system technology in the near future: increasing main memory capacities of several TB per server and massively parallel multi-core processing. Many algorithmic and control techniques in current database technology were devised for diskbased systems where I/O dominated the performance. In this work we take a new look at the well-known sort-...
متن کاملPointer-Based Join Techniques for Object-Oriented Databases
In this paper, we describe and analyze four parallel pointer-based joins for set-valued attributes. These joins will be common in next-generation object-oriented database systems, so efficiently supporting them is crucial to the performance of such systems. Pointer-based join algorithms based on Hybrid-hash provide good performance, but algorithms that require less replication will often produc...
متن کاملDPG: A Cache-Efficient Accelerator for Sorting and for Join Operators
Sorting and join are the heart of most database operations. For main memory databases, the two operations are memory bounded not CPU. Especially the common step in both of them, record retrieval, causes a lot of random memory accesses. We present a new algorithm for fast record retrieval, distributeprobe-gather, or DPG. DPG is a cache conscious two pass algorithm for the main memory record retr...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1996